package com.sky.mapper;

import com.sky.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDateTime;
import java.util.List;
import java.util.Map;

@Mapper
public interface UserMapper {


    @Select("select  * from  user where  openid =#{openid}")
    User getByOpenid(String openid);

    void insert(User user);

    @Select("select * from user where id = #{userId}")
    User getById(Long userId);

    @Select("select * from user where create_time >= #{beginTime} and create_time <= #{endTime} order by create_time asc")
    List<User> getByCreateTime(LocalDateTime beginTime, LocalDateTime endTime);

    Integer countByMap(Map map);
}
